Sets the starting and ending values of a range, and applies it.
procedure SetRange(const StartValues: array of System.TVarRec; const EndValues: array of System.TVarRec; StartExlusive: Boolean = False; EndExclusive: Boolean = False);
Call SetRange to specify a range and apply it to the dataset. The new range replaces the currently specified range, if any.
SetRange combines the functionality of SetRangeStart, SetRangeEnd, and ApplyRange in a single procedure call. SetRange performs the following functions:
After a call to SetRange, the cursor is left on the first record in the range.
Note: StartValues or EndValues must contain values for the fields specified in the IndexFieldNames property. To limit the number of fields used to set the range, use the RangeFieldCount property.